Round 1 – Technical Screening (Duration: 1 to 1.5 hours)

🔹 Discussed past project experiences.

🔹 Deep dive into Data Engineering projects mentioned in the resume.

🔹 Questions related to Databricks architecture.

🔹 Detailed discussion on Snowflake-based ETL project from the resume.

🔹 Questions on optimizing ETL pipelines.

🔹 Scenario-based ETL design questions.

🔹 In-depth discussion on Apache Spark architecture.

🔹 Explored Spark processing styles.

🔹 Techniques for performance optimization in Spark.

🔹 SQL-based questions, especially around window functions.

🔹 Real-time use case questions on Apache Airflow.

🔹 Questions on AWS Glue, Lambda, and EMR.

🔹 Deep dive into the migration project mentioned in the resume.

Round 2 – HR Discussion

🔹 Provided an overview of PwC and its organizational structure.

🔹 Asked about my current and expected compensation/package.

🔹 Discussed salary expectations, including bonuses.

🔹 Clarified that variable pay is not included in the payslip or offer letter.

🔹 Explored my openness to learning and upskilling in emerging technologies.

🔹 Asked about flexibility with shifts and ability to handle high-pressure phases at work.

🔹 Took about a week to finalize and release the offer letter.